Discovering MySQL Bugs

November 23, 2009 · 64 views · 0 comments

Nearby In Time

Bunnies Bunnies November 21, 2009 Memory with LSL vs Mono Memory with LSL vs Mono November 22, 2009 Online! Online! November 22, 2009 Inventory Loss Inventory Loss November 22, 2009 Discovering MySQL Bugs Discovering MySQL Bugs November 23, 2009 Lightweight Vendors Lightweight Vendors November 23, 2009 PDO thinks integers are strings PDO thinks integers are strings November 23, 2009 Pagination Workaround Pagination Workaround November 23, 2009 Web Interface via jQuery Web Interface via jQuery November 24, 2009
Discovering MySQL Bugs
taken by : Dedric Mauriac on Woodbridge (8, 2, 97)

About

I was going a bit nuts trying to find out why I was getting an error when adding one of my inventory items to the database. I have a primary key that contains a varchar(64) data type as one if it's keys. One item got in the database that was 63 characters long. I tried to add another item with the same name, except that it had a trailing space. It appears that MySQL thinks that this is the same name without the trailing space. It appears that it may be related to Bug #14131. I'll look into changing the collation from PADSPACE to NOPAD. From Dedric Mauriac via bloghud.com